﻿<%@ Page Language="VB" AutoEventWireup="false" CodeFile="mark.aspx.vb" Inherits="delivery_read" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" DeleteCommand="DELETE FROM [delivery_items] WHERE [dKey] = @dKey" InsertCommand="INSERT INTO [delivery_items] ([serial], [storename], [storeip], [guestname], [guestaddress], [contactno], [order_], [totalbill], [specialins], [changefor], [status], [datesent], [datedelivered], [timestamp], [sender]) VALUES (@serial, @storename, @storeip, @guestname, @guestaddress, @contactno, @order_, @totalbill, @specialins, @changefor, @status, @datesent, @datedelivered, @timestamp, @sender)" SelectCommand="SELECT * FROM [delivery_items]" UpdateCommand="UPDATE delivery_items SET status = @status, datedelivered = @datedelivered WHERE (dKey = @dKey)">
            <DeleteParameters>
                <asp:Parameter Name="dKey" Type="Int64" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="serial" Type="String" />
                <asp:Parameter Name="storename" Type="String" />
                <asp:Parameter Name="storeip" Type="String" />
                <asp:Parameter Name="guestname" Type="String" />
                <asp:Parameter Name="guestaddress" Type="String" />
                <asp:Parameter Name="contactno" Type="String" />
                <asp:Parameter Name="order_" Type="String" />
                <asp:Parameter Name="totalbill" Type="Double" />
                <asp:Parameter Name="specialins" Type="String" />
                <asp:Parameter Name="changefor" Type="Double" />
                <asp:Parameter Name="status" Type="String" />
                <asp:Parameter Name="datesent" Type="String" />
                <asp:Parameter Name="datedelivered" Type="String" />
                <asp:Parameter Name="timestamp" Type="DateTime" />
                <asp:Parameter Name="sender" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:QueryStringParameter Name="status" QueryStringField="mark" Type="String" />
                <asp:QueryStringParameter Name="dKey" QueryStringField="dKey" Type="Int64" />
                <asp:SessionParameter Name="datedelivered" SessionField="DateModify" />
            </UpdateParameters>
        </asp:SqlDataSource>
    </form>
    <p>
        ?mark=OPEN</p>
    <p>
        ?mark=READ,CLOSE</p>
    <p>
        &amp;dKey=1</p>
    <p>
        &nbsp;</p>
</body>
</html>
